package com.bsoft.exchange.dao.his;


import java.sql.SQLException;
import java.util.Date;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.bsoft.exchange.domain.QueueCallDomain;


@Mapper
public interface QueueCallMapper {

		/**
		 * 获取预约信息
		 */
		QueueCallDomain getGhxx(@Param("ghxh")int yyxh, @Param("jgid")int jgid);
		/**
		 * 插入队列表
		 */
		Integer insertDlb(@Param("jgid")int jgid, @Param("rdid")int rdid,@Param("dlid")int dlid, @Param("rdsj")Date rdsj,@Param("kssj")Date kssj,@Param("pdhm")int pdhm, @Param("pdcy")String pdcy,@Param("pdzt")int pdzt, @Param("ksid")String ksid, @Param("ksmc")String ksmc,@Param("ysid")String ysid, @Param("ysxm")String ysxm,@Param("qtid")String qtid, @Param("qtmc")String qtmc, @Param("ywlb")String ywlb, @Param("ywid")String ywid, @Param("brid")String brid, @Param("sxh")int sxh, @Param("cyly")int cyly, @Param("fzbz")int fzbz, @Param("hzbj")int hzbj, @Param("zblb")int zblb, @Param("zdys")int zdys);
		/**
		 * 获取科室对应队列
		 */
		Integer getKsdlid(@Param("ksdm")int ksdm,@Param("jgid")int jgid) ;
		/**
		 * 获取医生对应队列
		 */
		Integer getYsdlid(@Param("ksdm")String ksdm,@Param("ysdm")String ysdm,@Param("jgid")int jgid);
		
		/**
		 * 获取pd_dlib的rdid
		 */
		Integer getRdid(@Param("ywid")String ywid,@Param("jgid")int jgid);
		/**
		 * 获取pd_lsdl的rdid
		 */
		Integer getRdidLs(@Param("ywid")String ywid,@Param("jgid")int jgid);
		
		/**
		 * 删除pd_dlb数据
		 */
		Integer deleteDlb(@Param("rdid")int rdid,@Param("jgid")int jgid);
		
		/**
		 * 删除pd_lsdl数据
		 */
		Integer deleteLsdl(@Param("rdid")int rdid,@Param("jgid")int jgid);
		
		/**
		 * 获取pdzt
		 */
		Integer getPdzt(@Param("rdid")int rdid,@Param("jgid")int jgid);
}
